EVE Search - Yapeal PHP API library

Check My IP Information

All Channels

EVE Technology Lab

Yapeal PHP API library

» Click here to find additional results for this topic using Google

Monitor this thread via RSS [?]


Author	Thread Statistics \| Show CCP posts - 0 post(s)
Rottw Adleweh	Posted - 2009.12.02 09:57:00 - [1] What is the easiest way to update yapeal? To install it on my server I used an export of the SVN as I can't use any of the installers on my Unix box. I used the setup.php in the installer directory to get the database sorted out, but how can I now get the new API tables in the current database and if I again export the svn can I just copy it over the existing dir?
Rottw Adleweh	Posted - 2009.12.02 21:10:00 - [2] Originally by: Dragonaire Quote: ... I can't use any of the installers on my Unix box. Just wondering why you couldn't? Because FreeBSD doesn't run linux binaries out of the box. I can install linux compat, but don't want to install things I don't really need.
Rottw Adleweh	Posted - 2009.12.03 07:24:00 - [3] Nah, no need for the installer, works like this pretty well. Something I came across during initial installation thought: step 1: navigate to <yapeal-host>/install/setup.php step 2: set initial database credentials step 3: setup does creating all the tables and stuff and says its done step 4: go back to <yapeal-host>/install/setup.php to check other things/update database ----- At this point you get a login screen, but the password has never been set. I expected that the password thus was set to admin or so. But it turned out to not been set at all, so it is impossible to log on. At first I simply disabled the line in the phpcode that checked the password and substituted it with a line that is aways true. That let me get through the setupscreen where you can set the password. For some reason it didn't work either, but it showed me that I had to set the password in the database, but the field doesn't initially exist. So it took a while to figure out where to set the pw and how to make sure I can login, because that wasn't possible until manually added a record called: [password][md5(passwd)] in the utilConfig table.
Rottw Adleweh	Posted - 2009.12.06 19:56:00 - [4] I haven't updated to the above version yet, but after the dominion update I also had problems that api wasn't pulling things. With that update I used the setup.php to update the tables. I just found that in the utilSections table the values for all but the ServerStatus was set to 0. I don't know if it was because of the update or because the api was down during deployment of Dominion. But setting the values back to 1 fixed the problems I had.
Rottw Adleweh	Posted - 2009.12.17 12:19:00 - [5] Check this page: http://wiki.eve-id.net/APIv2_Corp_MarketOrders_XML
Rottw Adleweh	Posted - 2010.05.28 14:37:00 - [6] @Dragonaire I was wondering how hard it would be for me to switch my database backend to postgre. I know yapeal has been developed with mysql as the backend and I haven't really looked into the code to figure out how tied it is to mysql. Some tools you just need to configure to use another 'driver' to access another type of sql backend, I'm not sure how easy it would be with yapeal though. Could you give me a guestimate on how much I have to change to port it to a postgre backend? (as in 'a hell of a lot' or 'just a few lines')
Rottw Adleweh	Posted - 2010.06.14 08:34:00 - [7] erm, how hard would making an Mac os x installer be? btw I still plan to contact you about the postgre soonish, but too busy to get on it yet.
Rottw Adleweh	Posted - 2010.06.15 13:11:00 - [8] I wouldn't mind providing some test results.
Rottw Adleweh	Posted - 2010.06.22 09:58:00 - [9] Could you post a Mac installer with the downloads? I'll take it for a spin this week if you do.
Rottw Adleweh	Posted - 2011.07.11 20:26:00 - [10] I'm currently experiencing some problems with r1171. The wallet transactions don't seem to get fetched and I see this message in the logs: Quote: WARNING: Row has extra unknown fields (journalTransactionID) that will be ignored for corpWalletTransactions File: /Library/Yapeal/class/YapealQueryBuilder.php(191) Although to my interpretation of the message my transactions should still be written to the database. Plus: Quote: WARNING: API connection error: Operation too slow. Less than 10 bytes/sec transfered the last 12 seconds HTML error for API http://api.eveonline.com/eve/ConquerableStationList.xml.aspx File: /Library/Yapeal/class/YapealNetworkConnection.php(93) And finally very often: Quote: WARNING: API connection error: error:140770FC:SSL routines:SSL23_GET_SERVER_HELLO:unknown protocol Does anyone has an idea what the problem is and if it's fixable?

Rottw Adleweh	Posted - 2011.07.12 19:59:00 - [11] Edited by: Rottw Adleweh on 12/07/2011 20:03:10 Edited by: Rottw Adleweh on 12/07/2011 20:02:35 Originally by: Dragonaire Hi, it seems there was a change to the WalletTransactions API that wasn't in the notes I've updated the cache//.xsd, install/corp.xml and install.char.xml files to reflect the new journalTransactionID field. You'll need to update your database using install\createMySQLTables.php as per step 8 in INSTALL.txt. I've added an updated cert file in config/eveonline.crt to see if that helps with the other APIs errors that people have been having. revision 1175 Confirming this works to fix the WalletTransaction stuff. I do still get some (but much less than before) SSL errors. And some of these: Quote: WARNING: API connection error: Operation too slow. Less than 10 bytes/sec transfered the last 12 seconds HTML error for API http://api.eveonline.com/account/AccountStatus.xml.aspx File: /Library/Yapeal/class/YapealNetworkConnection.php(93) I know I have a slow connection, but not that slow ;) I also find it interesting to see the http instead of https, I see them on several API calls including Characters and ServerStatus which are all in the /server or /account API calls, maybe that has something to do with it? Oh and while running the install/createMySQLTables.php script I got this: Quote: Failed to execute schema for util Not all files processed correctly I'm not sure on the cause of it, but it happened to both of my instances of yapeal that I run, which both have their origin quite a few versions back.
Rottw Adleweh	Posted - 2011.07.13 19:03:00 - [12] Edited by: Rottw Adleweh on 13/07/2011 19:04:04 Sorry ... I didn't wanna make you look bad I'm running r1176 now for a few hours and no SSL errors poked up, so I believe it's completely fixed now. Oh, and did I already say somewhere that you really rock for making yapeal?

COPYRIGHT NOTICE
EVE Online, the EVE logo, EVE and all associated logos and designs are the intellectual property of CCP hf. All artwork, screenshots, characters, vehicles, storylines, world facts or other recognizable features of the intellectual property relating to these trademarks are likewise the intellectual property of CCP hf. EVE Online and the EVE logo are the registered trademarks of CCP hf. All rights are reserved worldwide. All other trademarks are the property of their respective owners. CCP hf. has granted permission to EVE-Search.com to use EVE Online and all associated logos and designs for promotional and information purposes on its website but does not endorse, and is not in any way affiliated with, EVE-Search.com. CCP is in no way responsible for the content on or functioning of this website, nor can it be liable for any damage arising from the use of this website.